package com.ruoyi.ly.mapper;


import com.ruoyi.ly.domain.SpaceSite;
import com.ruoyi.ly.domain.SpaceSiteGroup;
import com.ruoyi.ly.domain.dto.WorkSpaceUpdateDTO;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface SpaceSiteMapper {

    //对工位表进行增加操作
    @Insert("insert into space_site(site_group_id,site_name,firm_id,status)values(#{siteGroupId},#{siteName},#{firmId},#{status})")
    void insert(SpaceSite spaceSite);

    //根据site_group_id查询工位表
    @Select("select site_name from space_site where site_group_id=#{siteGroupId}")
    List<String> selectBySiteGroupId(Long siteGroupId);

    //先删除工位为 后面插入准备
    @Delete("delete from space_site where site_group_id=#{siteGroupId}")
    void delete(Long siteGroupId);
}
